package com.shuyu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.shuyu.domain.NFT;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface NFTMapper extends BaseMapper<NFT> {
    @Select("select t1.product_id,t1.transaction_hash,t1.token_id,t1.wallet,t1.create_time,t2.collection_code,t1.active_status " +
            "from tbl_nft t1 " +
            "LEFT JOIN tbl_product_card_code t2 on t1.transaction_hash=t2.transaction_hash " +
            "where t1.product_id = #{productId};")
    List<NFT> getNFTList(Integer productId);
}
